package com.ruoyi.personal.mapper;

import com.ruoyi.personal.domain.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Service;

import java.util.List;

@Mapper
public interface PhoneMapper {


    @Select("select numid, username,phone_number as phoneNumber from t_user;")
    public List<User> selectPhoneAll();

    @Update("UPDATE t_user SET phone_number = #{phoneNumber} WHERE numid = #{numid};")
    int updatePhoneNumber(@Param("numid") String numid, @Param("phoneNumber") String phoneNumber);
}
